Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Viewing OLAP Catalog Metadata

A set of views, identified by the `ALL_OLAP2` prefix, presents the metadata in the OLAP Catalog. The metadata may have been created with the `CWM2` PL/SQL packages, with Enterprise Manager, or with Warehouse Builder. The `ALL_OLAP2` views are automatically populated whenever changes are made to the metadata.

A second set of views, identified by the `MRV_OLAP` prefix, also presents OLAP Catalog metadata. These views are used by the OLAP API to access data stored in relational tables, typically star schemas. These views are structured specifically to support fast querying by the OLAP API Metadata Reader. They must be explicitly refreshed whenever changes are made to the metadata.

See Also: Chapter 5, "OLAP Catalog Metadata Views" for more information on the `ALL_OLAP2` views. Chapter 19, "CWM2_OLAP_METADATA_REFRESH" for more information on refreshing metadata tables for the OLAP API.